package mercede.allTable;
import mercede.allDTOs.StandardpkDTO;

import java.io.Serializable;

import javax.persistence.*;


/**
 * The persistent class for the standardpk database table.
 * 
 */
@Entity
@NamedQueries({@NamedQuery(name="Standardpk.FIND_ALL", query="SELECT s FROM Standardpk s"),
	@NamedQuery(name="Standardpk.DELETE",query="DELETE FROM Standardpk s WHERE s.sID=:sid"),
 @NamedQuery(name="Standardpk.FIND_BY_DEST", query="SELECT s FROM  Standardpk s WHERE s.sCity=:scity")})
public class Standardpk implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	private int sID;

	private String sCity;

	private String sExcursion;

	private String sFlight;

	private String sHotel;

	private String sNofdays;

	private String sPrice;
	
	
	
	public Standardpk() {
		super();

	}
	
	public Standardpk(StandardpkDTO standardpkdto)
	{
		this.sID= standardpkdto.getsID();
		this.sCity=standardpkdto.getsCity();
		this.sExcursion=standardpkdto.getsExcursion();
		this.sFlight=standardpkdto.getsFlight();
		this.sHotel=standardpkdto.getsHotel();
		this.sNofdays=standardpkdto.getsNofdays();
		this.sPrice=standardpkdto.getsPrice();
		
		}

	public int getSID() {
		return this.sID;
	}

	public void setSID(int sID) {
		this.sID = sID;
	}

	public String getSCity() {
		return this.sCity;
	}

	public void setSCity(String sCity) {
		this.sCity = sCity;
	}

	public String getSExcursion() {
		return this.sExcursion;
	}

	public void setSExcursion(String sExcursion) {
		this.sExcursion = sExcursion;
	}

	public String getSFlight() {
		return this.sFlight;
	}

	public void setSFlight(String sFlight) {
		this.sFlight = sFlight;
	}

	public String getSHotel() {
		return this.sHotel;
	}

	public void setSHotel(String sHotel) {
		this.sHotel = sHotel;
	}

	public String getSNofdays() {
		return this.sNofdays;
	}

	public void setSNofdays(String sNofdays) {
		this.sNofdays = sNofdays;
	}

	public String getSPrice() {
		return this.sPrice;
	}

	public void setSPrice(String sPrice) {
		this.sPrice = sPrice;
	}
	
	@Override
    public String toString() { 
		return "Standardpk [sID="+sID+"sCity="+sCity+"sExcusion="+sExcursion+"sFlight="+sFlight+"sHotel="+sHotel+
				"sNofdays="+sNofdays+"sPrice="+sPrice+"]";
	
	}
	
	
}